package com.jiexinyun.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.jiexinyun.entity.PpOutputEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface PpOutputMapper extends BaseMapper<PpOutputEntity> {

    //mybatis写法
    @Select(value = "SELECT CASE WHEN MAX(ID) IS NULL THEN 1 ELSE MAX(ID) END AS ID FROM wise_pp_output")
    Integer findMaxID();

}
